﻿SELECT TABLE_SCHEMA as [Schema], TABLE_NAME [Table]
FROM  INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE='TABLE'